
CREATE PROCEDURE [dbo].[InitializeLand] 
AS
BEGIN 
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Go','S',NULL,0,1)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Mediter-ranean Avenue','L','#8B4513',1,2)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Community Chest','CC',NULL,0,3)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Baltic Avenue','L','#8B4513',1,4)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Income Tax','T',NULL,0,5)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Reading Railroad','TR',NULL,1000,6)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Oriental Avenue','L','#87CEEB',2,7)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Chance','C',NULL,0,8)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Vermont Avenue','L','#87CEEB',2,9)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Connecticut Avenue','L','#87CEEB',2,10)
	
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('In Jail/Just Visiting','S',NULL,0,11)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('St. Charles Place','L','#9932CC',3,12)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Electric Company','U',NULL,2000,13)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('States Avenue','L','#9932CC',3,14)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Virginia Avenue','L','#9932CC',3,15)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Pennsylvania Railroad','TR',NULL,1000,16)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('St. James Place','L','#FFA500',4,17)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Community Chest','CC',NULL,0,18)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Tennessee Avenue','L','#FFA500',4,19)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('New York Avenue','L','#FFA500',4,20)
	
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Free Parking','S',NULL,0,21)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Kentucky Avenue','L','#FF0000',5,22)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Chance','C',NULL,0,23)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Indiana Avenue','L','#FF0000',5,24)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Illinois Avenue','L','#FF0000',5,25)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('B&O Railroad','TR',NULL,1000,26)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Atlantic Avenue','L','#FFFF00',6,27)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Ventnor Avenue','L','#FFFF00',6,28)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Water Works','U',NULL,2000,29)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Marvin Gardens','L','#FFFF00',6,30)
	
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Go To Jail','S',NULL,0,31)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Pacific Avenue','L','#008000',7,32)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('North Carolina Avenue','L','#008000',7,33)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Community Chest','CC',NULL,0,34)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Pennsylvania Avenue','L','#008000',7,35)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Short Line','TR',NULL,1000,36)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Chance','C',NULL,0,37)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Park Place','L','#0000FF',8,38)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Luxury Tax','T',NULL,0,39)
	INSERT INTO [dbo].[Land]([Name],[Type],Color,[Group],Position) VALUES('Boardwalk','L','#0000FF',8,40)

END

-- [dbo].[InitializeLand] 